SQL ManualFunctionsAggregate FunctionsMAXOn this pageMAXMAXDescriptionSyntax:MAX(expr)This function returns the maximum value of expr.ExampleMySQL > select max(scan_rows) from log_statis group by datetime;+------------------+| max(`scan_rows`) |+------------------+| 4671587 |+------------------+KeywordsMAX